package net.jsoft.pms.repository.grouprelationship;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.transaction.annotation.Transactional;

import net.jsoft.platform.security.entity.user.SysUser;
import net.jsoft.pms.entity.grouprelationship.GroupRelationship;

@Transactional
public interface GroupRelationshipRepository extends JpaSpecificationExecutor<GroupRelationship>, PagingAndSortingRepository<GroupRelationship, Long>
{
    @Query("from GroupRelationship where confirmedUser = ?1 and dealDate is null")
    List<GroupRelationship> findProGroupRelationship(SysUser user);

}
